Access & Mysql properties problem - Microsoft Access / VBA

Smriti Dev

Hi,

I have a question regarding autonumbering . I'm using linked tables between
msql and MS Access. Quite a few linked tables exist with relationships. The
auto increment fields once linked loose thier autonumber property and come
up as numbers.

I have developed a form interface and when I press the next record the next
number does not come as the autonumber property has been lost. Thier are
quite a few relationships with linked tables to the mysql database and I
need the primary numbers of those tables within the forms to appear
automatically.

I would really appreciate you help with this problem.

Looking forward to hearing from you.

Smriti

Nov 12 '05 #1

Subscribe Reply

1715

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In Access (JET db engine) when a record is "started" in a form, the
AutoNumber is created. In some other db engine's the AutoNumber (or
Identity number) is created after the record is "finished" in the form
(just before it is saved to the table).

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP5IJXYechKq OuFEgEQJQGwCg1Y eWGPzX2An+fLUTo KM/FIS3NY8An1ks
tnkJbVjf74KqOt5 sZVXIpCFV
=36gA
-----END PGP SIGNATURE-----

Smriti Dev wrote:

Hi,

I have a question regarding autonumbering . I'm using linked tables between
msql and MS Access. Quite a few linked tables exist with relationships. The
auto increment fields once linked loose thier autonumber property and come
up as numbers.

I have developed a form interface and when I press the next record the next
number does not come as the autonumber property has been lost. Thier are
quite a few relationships with linked tables to the mysql database and I
need the primary numbers of those tables within the forms to appear
automatically.

I would really appreciate you help with this problem.

Looking forward to hearing from you.

Smriti

Nov 12 '05 #2

Similar topics

3269

PHP, MySQL & Limiting Access

by: Jay Moore | last post by:

Greetings, all! I have a project for work, and I'm not sure how to efficiently do what I need to do. I'm hoping someone out there can help. Project is this: I'm creating a web-based interface where people at my company (operators) can enter data for service calls. All data entered is run thru one or more PHP scripts for error checking...

PHP

1774

ASP & Access Database

by: Earl Partridge | last post by:

Windows XP, Frontpage 2000, IIS 5.1, Access 2000 When I attempt to open a connection to my database I get an error the page cannot be found... this on my local machine, using localhost. The page works correctly when viewed on my host's site. The code: Set Conn = Server.CreateObject("ADODB.Connection") Conn.open "gmarc"

ASP / Active Server Pages

2742

ODBC, MySQL & Access 2003

by: Steve Farber | last post by:

I'm not especially new to databases and I have used ODBC before with other data sources, but I cannot seem to get Access 2003 to talk to MySQL 4.0.15. I have MySQL running with new tables defined, but I cannot get a connection to those tables via ODBC using MyODBC 3.51. Can anyone point the way? Many thanks,

MySQL Database

1351

ACCESS Database & MySQL and properties in PHPMyAdmin

by: bettina | last post by:

I had an Access database and I had always used in my tables (whenever possible) pop up lists to choose elements.. for example, for a column I've wrote in "Datensatzherkunft" SELECT tbl.field1 FROM tbl WHERE tbl.field2 LIKE 'XXX'; or I could say that only certain values are allowed: "X";"O";"S" as an example. Now I have exported my Access...

PHP

3716

Access Data pages

by: TheCoder | last post by:

I am making a D-base with web conectivity for my class project. I have everything working but the subit button sends the data to the correct fields but afterwards it wants to reproduce new blank text boxes how do I stop this and how would I code it to redirect to a thank you page. All with out the help of a web server this has to br ran from...

Microsoft Access / VBA

1561

Database & DB Size Question

by: cover | last post by:

I have two distinctively different pieces of equipment that I'm trying to build a database for, each having 20 inputs which makes my mysql table 40 fields wide. Form one is for 'shakers' and form two is for 'conveyors'. About the only thing they will have in common is that they both share 'motorsize' and they both share 'bearing' although...

PHP

2434

MS Access, MySQL & MyODBC .....

by: gordon.dtr | last post by:

Hi, Has anyone had this problem ? I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11 standard log. I created my tables in MS Access, then exported them via ODBC to an externally hosted MySQL database (fasthosts) . I then import-linked

MySQL Database

4390

Ms Access 2003

by: Mell via AccessMonster.com | last post by:

Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server...

Microsoft Access / VBA

3539

& not retrieve from Mysql Database

by: subho2009 | last post by:

Hello friends, I have face a problem, the problem is that when i fetch data from mysql database i get '&' in the place of '&'. I am using php 5.1.2 and mysql version 5.0.11-beta. What is the problem? any body solve my problem? Please answer me. Thanks in advance!

MySQL Database

7461

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7730

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

6055

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5381

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

5101

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3509

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3491

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1956

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1068

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP