Jump to content


Photo

Read And Write To Microsoft Access Files


  • Please log in to reply
18 replies to this topic

#1 Melari

Melari

    GMC Member

  • New Member
  • 104 posts

Posted 04 May 2008 - 10:44 PM

Hi, I was wondering if there is a dll or something that I would be able to use to read and write to microsoft access files, (specifically the forms and the values in them).

Any help is greatly appreciated.

Thanks!
  • 0

#2 celebraces

celebraces

    GMC Member

  • GMC Member
  • 956 posts

Posted 10 May 2008 - 01:37 AM

If anyone knows of a way to interface with COM objects, you could use the Microsoft JET Database service. You could do it with PHP4GM, but it'd be a really roundabout way of doing it.

Edited by celebraces, 10 May 2008 - 01:38 AM.

  • 0

#3 Melari

Melari

    GMC Member

  • New Member
  • 104 posts

Posted 20 May 2008 - 11:26 PM

I thought they wer dot NET objects not COM
  • 0

#4 celebraces

celebraces

    GMC Member

  • GMC Member
  • 956 posts

Posted 21 May 2008 - 07:33 AM

Oh, I don't know. All I know is I utilize Access databases through PHP's COM interface. There's a .NET -> GM DLL floating around somewhere.
  • 0

#5 tuntis

tuntis

    GMC Member

  • New Member
  • 1839 posts

Posted 22 May 2008 - 12:52 PM

You could also use SQLite: there's a DLL for it AFAIK.
  • 0

#6 uuf6429

uuf6429

    Covac Software

  • New Member
  • 2522 posts

Posted 22 May 2008 - 07:48 PM

.NET is a list of collected technologies, which in fact work on core technologies.
In fact you could do whatyou want by installing the required COM object in delphi as a delphi control and then putting the correct delphi vs GM wrapper code. You'de be using the COM interface as directly as possible.
I suggest you leave .NET out of the question. .NET is slow enough, using GM to interface it would make it disasterous to use.
  • 0

#7 celebraces

celebraces

    GMC Member

  • GMC Member
  • 956 posts

Posted 22 May 2008 - 09:48 PM

Well if it's the only way to utilize Access databases, then you'd have to use .NET. I think the link for SQLite DLL is down.
  • 0

#8 uuf6429

uuf6429

    Covac Software

  • New Member
  • 2522 posts

Posted 23 May 2008 - 05:12 AM

@celebraces - Did you even look at my last post?!
  • 0

#9 celebraces

celebraces

    GMC Member

  • GMC Member
  • 956 posts

Posted 23 May 2008 - 06:50 AM

Yes... .NET / COM. What's the difference? The GM .NET DLL does practically the same thing as your Delphi method.
  • 0

#10 uuf6429

uuf6429

    Covac Software

  • New Member
  • 2522 posts

Posted 23 May 2008 - 01:23 PM

Oh nothing, it's just that .NET is 90% slowwer, and uses COM indirectly.
Look, many things use COM like activex, in process modules, BHOs... Now tell me why from the 50 of them on my PC is not a single .NET / managed code.
It's because .NET is rarely practical especially running it through an interpreter!

Edited by uuf6429, 23 May 2008 - 01:25 PM.

  • 0

#11 cdm319

cdm319

    C++ Programmer

  • New Member
  • 885 posts

Posted 24 May 2008 - 06:55 PM

uuf
if you look at things that way, then why is GM practical at all?
  • 0

#12 Arial

Arial

    GMC Member

  • Banned Users
  • 580 posts
  • Version:GM8

Posted 24 May 2008 - 07:27 PM

uuf
if you look at things that way, then why is GM practical at all?

I agree. :lol:

#13 Melari

Melari

    GMC Member

  • New Member
  • 104 posts

Posted 25 May 2008 - 01:36 AM

Yah, anyway I decided just to use VB. Much easier.
  • 0

#14 uuf6429

uuf6429

    Covac Software

  • New Member
  • 2522 posts

Posted 25 May 2008 - 08:47 AM

@ cdm319 - To me, it's not.
But the OP asked how to use access files from GM didn't s/he?
I could have told him/her just to use delphi for his entire project, which I would.

Edit: Next time learn to read and leave forecasts to witches. :lol:

Edited by uuf6429, 25 May 2008 - 03:54 PM.

  • 0

#15 TheMagicNumber

TheMagicNumber

    GMC Member

  • GMC Member
  • 5247 posts
  • Version:Unknown

Posted 25 May 2008 - 05:24 PM

Are you sure this is allowed with Game Maker? What exactly is it writing? So changing values inside of a form?

Strange...
  • 0

#16 celebraces

celebraces

    GMC Member

  • GMC Member
  • 956 posts

Posted 26 May 2008 - 09:31 AM

Why not? It's basically using an Access database for in-game stuff, right? So what's the harm?
  • 0

#17 TheMagicNumber

TheMagicNumber

    GMC Member

  • GMC Member
  • 5247 posts
  • Version:Unknown

Posted 26 May 2008 - 12:14 PM

You can edit existing files...you can change the way the computer works.
  • 0

#18 Chirantha

Chirantha

    GMC Member

  • New Member
  • 502 posts

Posted 27 May 2008 - 08:47 AM

You can edit existing files...you can change the way the computer works.

So can the file commands. :P
  • 0

#19 celebraces

celebraces

    GMC Member

  • GMC Member
  • 956 posts

Posted 27 May 2008 - 10:26 AM

I don't think Windows uses Access... I think you have Access databases and the registry confused.
  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users